DeleteRecordsetRow

Deletes the current row from a recordset. When a row is deleted, the rows after it move up to fill the empty index. If the last row is deleted, the active row is at RecordsetEOF.

Note: To delete a row from a Microsoft Access, Oracle, or SQL Server datasheet, a primary key must be defined. To delete a row from a Microsoft Excel datasheet, Excel must be installed on the computer running the script. If a primary key is not defined or Excel is not installed, QA Wizard Pro opens the recordset as read-only.

Syntax

DeleteRecordsetRow(Recordset)

Arguments

Argument Description
Recordset Recordset name to delete the row from. Must be opened with OpenRecordset or OpenRecordsetQuery.

Example

bugs = OpenRecordset("WysiCorp Bugs")

NextRow(bugs)

DeleteRecordsetRow(bugs)